DB2 and the operating system must enforce access restrictions associated with changes to the configuration of DB2 or database(s).

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-74591	DB2X-00-008100	SV-89265r1_rule		Medium

Description
Failure to provide logical access restrictions associated with changes to configuration may have significant effects on the overall security of the system. When dealing with access restrictions pertaining to change control, it should be noted that any changes to the hardware, software, and/or firmware components of the information system can potentially have significant effects on the overall security of the system. Accordingly, only qualified and authorized individuals should be allowed to obtain access to system components for the purposes of initiating changes, including upgrades and modifications.

Description

Failure to provide logical access restrictions associated with changes to configuration may have significant effects on the overall security of the system. When dealing with access restrictions pertaining to change control, it should be noted that any changes to the hardware, software, and/or firmware components of the information system can potentially have significant effects on the overall security of the system. Accordingly, only qualified and authorized individuals should be allowed to obtain access to system components for the purposes of initiating changes, including upgrades and modifications.

STIG	Date
IBM DB2 V10.5 LUW Security Technical Implementation Guide	2019-09-27

Details

Check Text ( C-74477r1_chk )
The base installation directory of the database server software and instance home directory location is configurable at the time of installation. Run the db2level command to find the installation directory of DB2 server software: $db2level If any user other than the sysadmin and root users has write permission on these directories and subsequent subdirectories under this directory, this is a finding. On Linux and UNIX operating systems, the instance directory is located in the $INSTHOME/sqllib directory, where $INSTHOME is the home directory of the instance owner. On Windows operating systems, the instance directory is located under the /sqllib directory where the DB2 database product was installed. If any user other than the instance owner and the root user has write permission to instance home directory and subsequent subdirectories under it, this is a finding.

Check Text ( C-74477r1_chk )

The base installation directory of the database server software and instance home directory location is configurable at the time of installation.

Run the db2level command to find the installation directory of DB2 server software:

$db2level

If any user other than the sysadmin and root users has write permission on these directories and subsequent subdirectories under this directory, this is a finding.

On Linux and UNIX operating systems, the instance directory is located in the $INSTHOME/sqllib directory, where $INSTHOME is the home directory of the instance owner.

On Windows operating systems, the instance directory is located under the /sqllib directory where the DB2 database product was installed.

If any user other than the instance owner and the root user has write permission to instance home directory and subsequent subdirectories under it, this is a finding.

Fix Text (F-81191r1_fix)
Remove the write permission from non-root/non-sysadmin users on the DB2 installation base directory and instance home directory.